Report

Dataset statistics

Number of variables	22
Number of observations	7051560
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	140696
Duplicate rows (%)	2.0%
Total size in memory	813.7 MiB
Average record size in memory	121.0 B

Variable types

Categorical	3
Numeric	7
Text	3
Boolean	9

Alerts

Dataset has 140696 (2.0%) duplicate rows	Duplicates
`Severity` is highly imbalanced (56.3%)	Imbalance
`Amenity` is highly imbalanced (90.3%)	Imbalance
`Give_Way` is highly imbalanced (95.7%)	Imbalance
`Junction` is highly imbalanced (62.3%)	Imbalance
`No_Exit` is highly imbalanced (97.4%)	Imbalance
`Railway` is highly imbalanced (92.9%)	Imbalance
`Stop` is highly imbalanced (81.7%)	Imbalance
`Traffic_Calming` is highly imbalanced (98.9%)	Imbalance
`Duration_Seconds` is highly skewed (γ1 = 50.61168934)	Skewed
`Distance(mi)` has 2959002 (42.0%) zeros	Zeros
`Wind_Speed(mph)` has 942813 (13.4%) zeros	Zeros

Reproduction

Analysis started	2024-11-04 23:33:25.030150
Analysis finished	2024-11-04 23:36:35.560166
Duration	3 minutes and 10.53 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

Severity
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

2	5671504
3	1136467
4	178538
1	65051

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	7051560
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	3
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Most occurring characters

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7051560	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7051560	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7051560	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	5671504	80.4%
3	1136467	16.1%
4	178538	2.5%
1	65051	0.9%

Distance(mi)
Real number (ℝ)

Zeros

Distinct	21687
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.56854528

Minimum	0
Maximum	441.75
Zeros	2959002
Zeros (%)	42.0%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.037
Q3	0.478
95-th percentile	2.697
Maximum	441.75
Range	441.75
Interquartile range (IQR)	0.478

Descriptive statistics

Standard deviation	1.7641632
Coefficient of variation (CV)	3.1029423
Kurtosis	1583.1938
Mean	0.56854528
Median Absolute Deviation (MAD)	0.037
Skewness	19.843757
Sum	4009131.2
Variance	3.1122718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2959002	42.0%
0.01	212576	3.0%
0.008	13880	0.2%
0.009	13182	0.2%
0.007	11733	0.2%
0.009999999776	11083	0.2%
0.011	11011	0.2%
0.03	10801	0.2%
0.024	10372	0.1%
0.028	10332	0.1%
Other values (21677)	3787588	53.7%

Value	Count	Frequency (%)
0	2959002	42.0%
0.001	4680	0.1%
0.002	2694	< 0.1%
0.003	3934	0.1%
0.004	5931	0.1%
0.005	7752	0.1%
0.006	9600	0.1%
0.007	11733	0.2%
0.008	13880	0.2%
0.009	13182	0.2%

Value	Count	Frequency (%)
441.75	1	< 0.1%
336.5700073	1	< 0.1%
254.3999939	1	< 0.1%
251.2200012	1	< 0.1%
242.3399963	1	< 0.1%
224.5899963	1	< 0.1%
210.0800018	1	< 0.1%
194.7299957	1	< 0.1%
193.4799957	1	< 0.1%
183.1199951	1	< 0.1%

Street
Text

Distinct	320207
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

Length

Max length	59
Median length	47
Mean length	11.063362
Min length	1

Characters and Unicode

Total characters	78013961
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	124428 ?
Unique (%)	1.8%

Sample

1st row	State Route 32
2nd row	I-75 S
3rd row	Miamisburg Centerville Rd
4th row	Westerville Rd
5th row	N Woodward Ave

Value	Count	Frequency (%)
n	1092408	6.2%
s	1088072	6.2%
rd	1056801	6.0%
w	859562	4.9%
e	849902	4.9%
st	629910	3.6%
ave	590604	3.4%
blvd	314610	1.8%
dr	301258	1.7%
fwy	286513	1.6%
Other values (71822)	10436013	59.6%

Most occurring characters

Value	Count	Frequency (%)
	12059741	15.5%
e	4346299	5.6%
a	3471039	4.4%
r	2955808	3.8%
t	2936495	3.8%
S	2722829	3.5%
o	2720548	3.5%
n	2713466	3.5%
d	2540155	3.3%
l	2520382	3.2%
Other values (70)	39027199	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	78013961	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	12059741	15.5%
e	4346299	5.6%
a	3471039	4.4%
r	2955808	3.8%
t	2936495	3.8%
S	2722829	3.5%
o	2720548	3.5%
n	2713466	3.5%
d	2540155	3.3%
l	2520382	3.2%
Other values (70)	39027199	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	78013961	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	12059741	15.5%
e	4346299	5.6%
a	3471039	4.4%
r	2955808	3.8%
t	2936495	3.8%
S	2722829	3.5%
o	2720548	3.5%
n	2713466	3.5%
d	2540155	3.3%
l	2520382	3.2%
Other values (70)	39027199	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	78013961	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	12059741	15.5%
e	4346299	5.6%
a	3471039	4.4%
r	2955808	3.8%
t	2936495	3.8%
S	2722829	3.5%
o	2720548	3.5%
n	2713466	3.5%
d	2540155	3.3%
l	2520382	3.2%
Other values (70)	39027199	50.0%

Zipcode
Text

Distinct	774620
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

Length

Max length	10
Median length	5
Mean length	6.4828095
Min length	5

Characters and Unicode

Total characters	45713920
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	426008 ?
Unique (%)	6.0%

Sample

1st row	45176
2nd row	45417
3rd row	45459
4th row	43081
5th row	45417-2476

Value	Count	Frequency (%)
91761	10683	0.2%
91706	8692	0.1%
92507	8177	0.1%
92407	8071	0.1%
33186	7929	0.1%
32819	7269	0.1%
33169	6658	0.1%
75243	6570	0.1%
92324	6322	0.1%
90805	6244	0.1%
Other values (774610)	6974945	98.9%

Most occurring characters

Value	Count	Frequency (%)
0	5737493	12.6%
2	5601412	12.3%
3	5244330	11.5%
1	5204712	11.4%
9	4041057	8.8%
7	3954685	8.7%
5	3858349	8.4%
4	3801049	8.3%
6	3151443	6.9%
8	3022532	6.6%
Other values (3)	2096858	4.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45713920	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	5737493	12.6%
2	5601412	12.3%
3	5244330	11.5%
1	5204712	11.4%
9	4041057	8.8%
7	3954685	8.7%
5	3858349	8.4%
4	3801049	8.3%
6	3151443	6.9%
8	3022532	6.6%
Other values (3)	2096858	4.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45713920	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	5737493	12.6%
2	5601412	12.3%
3	5244330	11.5%
1	5204712	11.4%
9	4041057	8.8%
7	3954685	8.7%
5	3858349	8.4%
4	3801049	8.3%
6	3151443	6.9%
8	3022532	6.6%
Other values (3)	2096858	4.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45713920	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	5737493	12.6%
2	5601412	12.3%
3	5244330	11.5%
1	5204712	11.4%
9	4041057	8.8%
7	3954685	8.7%
5	3858349	8.4%
4	3801049	8.3%
6	3151443	6.9%
8	3022532	6.6%
Other values (3)	2096858	4.6%

Temperature(F)
Real number (ℝ)

Distinct	829
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.869611

Minimum	-45
Maximum	196
Zeros	2651
Zeros (%)	< 0.1%
Negative	18053
Negative (%)	0.3%
Memory size	107.6 MiB

Quantile statistics

Minimum	-45
5-th percentile	28
Q1	49
median	64
Q3	76
95-th percentile	89
Maximum	196
Range	241
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	19.042054
Coefficient of variation (CV)	0.30777717
Kurtosis	-0.014583106
Mean	61.869611
Median Absolute Deviation (MAD)	13
Skewness	-0.52138711
Sum	4.3627728 × 10⁸
Variance	362.59983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	162688	2.3%
77	160720	2.3%
72	152716	2.2%
68	151851	2.2%
75	150957	2.1%
70	147290	2.1%
63	141625	2.0%
79	141137	2.0%
64	139891	2.0%
66	136900	1.9%
Other values (819)	5565785	78.9%

Value	Count	Frequency (%)
-45	1	< 0.1%
-38	3	< 0.1%
-36	2	< 0.1%
-35	9	< 0.1%
-33	1	< 0.1%
-30	1	< 0.1%
-29	8	< 0.1%
-28	5	< 0.1%
-27.9	12	< 0.1%
-27.4	3	< 0.1%

Value	Count	Frequency (%)
196	5	< 0.1%
189	1	< 0.1%
174	2	< 0.1%
172	2	< 0.1%
170.6	1	< 0.1%
168.8	1	< 0.1%
167	1	< 0.1%
162	2	< 0.1%
161.6	1	< 0.1%
143.6	1	< 0.1%

Humidity(%)
Real number (ℝ)

Distinct	100
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.415366

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	1
5-th percentile	24
Q1	48
median	67
Q3	84
95-th percentile	96
Maximum	100
Range	99
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	22.757178
Coefficient of variation (CV)	0.35328803
Kurtosis	-0.72760491
Mean	64.415366
Median Absolute Deviation (MAD)	18
Skewness	-0.38008968
Sum	4.5422882 × 10⁸
Variance	517.88913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93	264622	3.8%
100	246092	3.5%
87	156275	2.2%
90	154061	2.2%
89	128993	1.8%
96	120746	1.7%
81	117405	1.7%
84	117210	1.7%
82	114896	1.6%
86	112259	1.6%
Other values (90)	5519001	78.3%

Value	Count	Frequency (%)
1	45	< 0.1%
2	189	< 0.1%
3	656	< 0.1%
4	2070	< 0.1%
5	3970	0.1%
6	5781	0.1%
7	7731	0.1%
8	9169	0.1%
9	10550	0.1%
10	12848	0.2%

Value	Count	Frequency (%)
100	246092	3.5%
99	12864	0.2%
98	6129	0.1%
97	79382	1.1%
96	120746	1.7%
95	8565	0.1%
94	104894	1.5%
93	264622	3.8%
92	60688	0.9%
91	34646	0.5%

Pressure(in)
Real number (ℝ)

Distinct	1126
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.514437

Minimum	0
Maximum	58.63
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	0
5-th percentile	27.85
Q1	29.34
median	29.84
Q3	30.02
95-th percentile	30.24
Maximum	58.63
Range	58.63
Interquartile range (IQR)	0.68

Descriptive statistics

Standard deviation	1.0148514
Coefficient of variation (CV)	0.034384914
Kurtosis	19.955612
Mean	29.514437
Median Absolute Deviation (MAD)	0.25
Skewness	-3.5478432
Sum	2.0812282 × 10⁸
Variance	1.0299233
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.96	111934	1.6%
29.99	109652	1.6%
29.94	108617	1.5%
30.01	106437	1.5%
29.97	102676	1.5%
29.91	101754	1.4%
29.95	100739	1.4%
30.04	100576	1.4%
30.03	99319	1.4%
30	99191	1.4%
Other values (1116)	6010665	85.2%

Value	Count	Frequency (%)
0	2	< 0.1%
0.02	1	< 0.1%
0.29	2	< 0.1%
0.39	1	< 0.1%
2.99	5	< 0.1%
3	2	< 0.1%
3.01	1	< 0.1%
3.04	4	< 0.1%
9.9	2	< 0.1%
16.71	1	< 0.1%

Value	Count	Frequency (%)
58.63	7	< 0.1%
58.39	2	< 0.1%
58.32	1	< 0.1%
58.13	1	< 0.1%
58.1	4	< 0.1%
58.04	3	< 0.1%
57.74	1	< 0.1%
57.54	2	< 0.1%
56.54	2	< 0.1%
56.31	1	< 0.1%

Visibility(mi)
Real number (ℝ)

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1070711

Minimum	0
Maximum	140
Zeros	7236
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	0
5-th percentile	2.5
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	140
Range	140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.6422642
Coefficient of variation (CV)	0.29013326
Kurtosis	80.462982
Mean	9.1070711
Median Absolute Deviation (MAD)	0
Skewness	2.1147471
Sum	64219058
Variance	6.98156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	5701259	80.9%
7	194895	2.8%
9	172317	2.4%
8	136720	1.9%
5	130384	1.8%
6	116029	1.6%
2	115544	1.6%
4	109570	1.6%
3	108489	1.5%
1	98051	1.4%
Other values (71)	168302	2.4%

Value	Count	Frequency (%)
0	7236	0.1%
0.06	316	< 0.1%
0.1	870	< 0.1%
0.12	1749	< 0.1%
0.19	41	< 0.1%
0.2	7184	0.1%
0.25	26547	0.4%
0.31	4	< 0.1%
0.38	328	< 0.1%
0.4	52	< 0.1%

Value	Count	Frequency (%)
140	1	< 0.1%
111	3	< 0.1%
105	1	< 0.1%
101	1	< 0.1%
100	47	< 0.1%
98	1	< 0.1%
90	13	< 0.1%
80	295	< 0.1%
78	1	< 0.1%
76	3	< 0.1%

Wind_Direction
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

CALM	942803
S	413902
SSW	379701
W	378400
WNW	373374
Other values (18)	4563380

Length

Max length	8
Median length	5
Mean length	2.7674176
Min length	1

Characters and Unicode

Total characters	19514611
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SW
2nd row	SW
3rd row	SW
4th row	SSW
5th row	WSW

Common Values

Value	Count	Frequency (%)
CALM	942803	13.4%
S	413902	5.9%
SSW	379701	5.4%
W	378400	5.4%
WNW	373374	5.3%
NW	364394	5.2%
SW	359826	5.1%
WSW	348591	4.9%
SSE	344112	4.9%
NNW	328354	4.7%
Other values (13)	2818103	40.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
calm	942803	13.4%
s	413902	5.9%
ssw	379701	5.4%
w	378400	5.4%
wnw	373374	5.3%
nw	364394	5.2%
sw	359826	5.1%
wsw	348591	4.9%
sse	344112	4.9%
nnw	328354	4.7%
Other values (13)	2818103	40.0%

Most occurring characters

Value	Count	Frequency (%)
W	3416992	17.5%
S	3301407	16.9%
N	2833882	14.5%
E	2558297	13.1%
A	1189944	6.1%
M	942803	4.8%
L	942803	4.8%
C	942803	4.8%
t	564925	2.9%
V	359219	1.8%
Other values (11)	2461536	12.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19514611	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	3416992	17.5%
S	3301407	16.9%
N	2833882	14.5%
E	2558297	13.1%
A	1189944	6.1%
M	942803	4.8%
L	942803	4.8%
C	942803	4.8%
t	564925	2.9%
V	359219	1.8%
Other values (11)	2461536	12.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19514611	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	3416992	17.5%
S	3301407	16.9%
N	2833882	14.5%
E	2558297	13.1%
A	1189944	6.1%
M	942803	4.8%
L	942803	4.8%
C	942803	4.8%
t	564925	2.9%
V	359219	1.8%
Other values (11)	2461536	12.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19514611	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	3416992	17.5%
S	3301407	16.9%
N	2833882	14.5%
E	2558297	13.1%
A	1189944	6.1%
M	942803	4.8%
L	942803	4.8%
C	942803	4.8%
t	564925	2.9%
V	359219	1.8%
Other values (11)	2461536	12.6%

Wind_Speed(mph)
Real number (ℝ)

Zeros

Distinct	179
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6911295

Minimum	0
Maximum	1087
Zeros	942813
Zeros (%)	13.4%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4.6
median	7
Q3	10.4
95-th percentile	17
Maximum	1087
Range	1087
Interquartile range (IQR)	5.8

Descriptive statistics

Standard deviation	5.4122238
Coefficient of variation (CV)	0.70369688
Kurtosis	1088.9651
Mean	7.6911295
Median Absolute Deviation (MAD)	3
Skewness	7.9491258
Sum	54234461
Variance	29.292167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	942813	13.4%
5	526299	7.5%
6	508834	7.2%
3	506264	7.2%
7	473560	6.7%
8	426369	6.0%
9	383468	5.4%
10	319588	4.5%
12	276284	3.9%
4.6	214994	3.0%
Other values (169)	2473087	35.1%

Value	Count	Frequency (%)
0	942813	13.4%
1	166	< 0.1%
1.2	440	< 0.1%
2	427	< 0.1%
2.3	890	< 0.1%
3	506264	7.2%
3.5	201212	2.9%
4.6	214994	3.0%
5	526299	7.5%
5.8	213280	3.0%

Value	Count	Frequency (%)
1087	1	< 0.1%
984	1	< 0.1%
822.8	7	< 0.1%
812	1	< 0.1%
703.1	2	< 0.1%
580	2	< 0.1%
471.8	1	< 0.1%
328	1	< 0.1%
255	1	< 0.1%
254.3	2	< 0.1%

Weather_Condition
Text

Distinct	140
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

Length

Max length	35
Median length	30
Mean length	7.6752019
Min length	3

Characters and Unicode

Total characters	54122147
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Overcast
2nd row	Mostly Cloudy
3rd row	Mostly Cloudy
4th row	Light Rain
5th row	Overcast

Value	Count	Frequency (%)
fair	2536998	25.9%
cloudy	2472945	25.2%
mostly	983438	10.0%
partly	672146	6.9%
clear	615352	6.3%
light	519905	5.3%
rain	484808	4.9%
overcast	321868	3.3%
scattered	176183	1.8%
clouds	176183	1.8%
Other values (48)	840646	8.6%

Most occurring characters

Value	Count	Frequency (%)
l	4957471	9.2%
a	4945655	9.1%
r	4471321	8.3%
y	4315734	8.0%
o	3950113	7.3%
i	3805617	7.0%
C	3264496	6.0%
d	2999461	5.5%
t	2966355	5.5%
	2748912	5.1%
Other values (36)	15697012	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54122147	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	4957471	9.2%
a	4945655	9.1%
r	4471321	8.3%
y	4315734	8.0%
o	3950113	7.3%
i	3805617	7.0%
C	3264496	6.0%
d	2999461	5.5%
t	2966355	5.5%
	2748912	5.1%
Other values (36)	15697012	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54122147	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	4957471	9.2%
a	4945655	9.1%
r	4471321	8.3%
y	4315734	8.0%
o	3950113	7.3%
i	3805617	7.0%
C	3264496	6.0%
d	2999461	5.5%
t	2966355	5.5%
	2748912	5.1%
Other values (36)	15697012	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54122147	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	4957471	9.2%
a	4945655	9.1%
r	4471321	8.3%
y	4315734	8.0%
o	3950113	7.3%
i	3805617	7.0%
C	3264496	6.0%
d	2999461	5.5%
t	2966355	5.5%
	2748912	5.1%
Other values (36)	15697012	29.0%

Amenity
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6963701
True	87859

Value	Count	Frequency (%)
False	6963701	98.8%
True	87859	1.2%

Crossing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6243875
True	807685

Value	Count	Frequency (%)
False	6243875	88.5%
True	807685	11.5%

Give_Way
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	7018855
True	32705

Value	Count	Frequency (%)
False	7018855	99.5%
True	32705	0.5%

Junction
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6537106
True	514454

Value	Count	Frequency (%)
False	6537106	92.7%
True	514454	7.3%

No_Exit
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	7033447
True	18113

Value	Count	Frequency (%)
False	7033447	99.7%
True	18113	0.3%

Railway
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6990994
True	60566

Value	Count	Frequency (%)
False	6990994	99.1%
True	60566	0.9%

Stop
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6856170
True	195390

Value	Count	Frequency (%)
False	6856170	97.2%
True	195390	2.8%

Traffic_Calming
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	7044580
True	6980

Value	Count	Frequency (%)
False	7044580	99.9%
True	6980	0.1%

Traffic_Signal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.5 MiB

False	6009292
True	1042268

Value	Count	Frequency (%)
False	6009292	85.2%
True	1042268	14.8%

Civil_Twilight
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	107.6 MiB

Day	5246527
Night	1805033

Length

Max length	5
Median length	3
Mean length	3.5119528
Min length	3

Characters and Unicode

Total characters	24764746
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Day
3rd row	Day
4th row	Day
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	5246527	74.4%
Night	1805033	25.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
day	5246527	74.4%
night	1805033	25.6%

Most occurring characters

Value	Count	Frequency (%)
D	5246527	21.2%
a	5246527	21.2%
y	5246527	21.2%
N	1805033	7.3%
i	1805033	7.3%
g	1805033	7.3%
h	1805033	7.3%
t	1805033	7.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24764746	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	5246527	21.2%
a	5246527	21.2%
y	5246527	21.2%
N	1805033	7.3%
i	1805033	7.3%
g	1805033	7.3%
h	1805033	7.3%
t	1805033	7.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24764746	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	5246527	21.2%
a	5246527	21.2%
y	5246527	21.2%
N	1805033	7.3%
i	1805033	7.3%
g	1805033	7.3%
h	1805033	7.3%
t	1805033	7.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24764746	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	5246527	21.2%
a	5246527	21.2%
y	5246527	21.2%
N	1805033	7.3%
i	1805033	7.3%
g	1805033	7.3%
h	1805033	7.3%
t	1805033	7.3%

Duration_Seconds
Real number (ℝ)

Skewed

Distinct	72892
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26947.592

Minimum	120
Maximum	1.6877634 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	107.6 MiB

Quantile statistics

Minimum	120
5-th percentile	1718
Q1	2068
median	4502
Q3	7539
95-th percentile	21600
Maximum	1.6877634 × 10⁸
Range	1.6877622 × 10⁸
Interquartile range (IQR)	5471

Descriptive statistics

Standard deviation	816632.16
Coefficient of variation (CV)	30.304458
Kurtosis	3685.2728
Mean	26947.592
Median Absolute Deviation (MAD)	2707
Skewness	50.611689
Sum	1.9002256 × 10¹¹
Variance	6.6688808 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21600	301728	4.3%
1800	101353	1.4%
2700	61354	0.9%
4500	58442	0.8%
3600	55270	0.8%
14400	50458	0.7%
1786	46694	0.7%
1785	46645	0.7%
1787	45598	0.6%
1784	45229	0.6%
Other values (72882)	6238789	88.5%

Value	Count	Frequency (%)
120	2	< 0.1%
150	3	< 0.1%
152	1	< 0.1%
180	16	< 0.1%
210	6	< 0.1%
221	1	< 0.1%
229	1	< 0.1%
240	12	< 0.1%
270	5	< 0.1%
271	1	< 0.1%

Value	Count	Frequency (%)
168776340	2	< 0.1%
134184345	1	< 0.1%
134181332	3	< 0.1%
134179838	3	< 0.1%
134176830	2	< 0.1%
106135755	1	< 0.1%
100954757	1	< 0.1%
94755540	1	< 0.1%
94697995	1	< 0.1%
94697990	1	< 0.1%

	Amenity	Civil_Twilight	Crossing	Distance(mi)	Duration_Seconds	Give_Way	Humidity(%)	Junction	No_Exit	Pressure(in)	Railway	Severity	Stop	Temperature(F)	Traffic_Calming	Traffic_Signal	Visibility(mi)	Wind_Direction	Wind_Speed(mph)
Amenity	1.000	0.006	0.148	0.000	0.002	0.006	0.015	0.026	0.014	0.023	0.050	0.038	0.034	0.010	0.023	0.105	0.002	0.023	0.000
Civil_Twilight	0.006	1.000	0.039	0.003	0.007	0.005	0.245	0.015	0.004	0.035	0.000	0.058	0.001	0.280	0.000	0.045	0.015	0.183	0.001
Crossing	0.148	0.039	1.000	0.004	0.008	0.058	0.036	0.088	0.062	0.036	0.179	0.119	0.118	0.062	0.037	0.476	0.007	0.054	0.001
Distance(mi)	0.000	0.003	0.004	1.000	0.394	0.000	-0.010	0.001	0.000	-0.108	0.000	0.005	0.002	-0.062	0.001	0.004	-0.014	0.001	-0.005
Duration_Seconds	0.002	0.007	0.008	0.394	1.000	0.001	-0.011	0.009	0.001	-0.112	0.001	0.009	0.004	-0.033	0.000	0.008	0.005	0.005	-0.038
Give_Way	0.006	0.005	0.058	0.000	0.001	1.000	0.004	0.009	0.006	0.007	0.003	0.008	0.030	0.005	0.003	0.072	0.007	0.010	0.000
Humidity(%)	0.015	0.245	0.036	-0.010	-0.011	0.004	1.000	0.009	0.009	0.043	0.006	0.028	0.026	-0.331	0.005	0.022	-0.464	0.084	-0.199
Junction	0.026	0.015	0.088	0.001	0.009	0.009	0.009	1.000	0.004	0.027	0.009	0.051	0.036	0.027	0.005	0.104	0.004	0.029	0.000
No_Exit	0.014	0.004	0.062	0.000	0.001	0.006	0.009	0.004	1.000	0.007	0.004	0.012	0.026	0.009	0.013	0.030	0.007	0.006	0.000
Pressure(in)	0.023	0.035	0.036	-0.108	-0.112	0.007	0.043	0.027	0.007	1.000	0.017	0.042	0.003	0.021	0.005	0.035	0.078	0.077	0.000
Railway	0.050	0.000	0.179	0.000	0.001	0.003	0.006	0.009	0.004	0.017	1.000	0.014	0.007	0.010	0.006	0.059	0.003	0.007	0.000
Severity	0.038	0.058	0.119	0.005	0.009	0.008	0.028	0.051	0.012	0.042	0.014	1.000	0.058	0.038	0.005	0.119	0.012	0.097	0.001
Stop	0.034	0.001	0.118	0.002	0.004	0.030	0.026	0.036	0.026	0.003	0.007	0.058	1.000	0.016	0.027	0.048	0.001	0.009	0.000
Temperature(F)	0.010	0.280	0.062	-0.062	-0.033	0.005	-0.331	0.027	0.009	0.021	0.010	0.038	0.016	1.000	0.006	0.047	0.228	0.083	0.088
Traffic_Calming	0.023	0.000	0.037	0.001	0.000	0.003	0.005	0.005	0.013	0.005	0.006	0.005	0.027	0.006	1.000	0.011	0.002	0.006	0.000
Traffic_Signal	0.105	0.045	0.476	0.004	0.008	0.072	0.022	0.104	0.030	0.035	0.059	0.119	0.048	0.047	0.011	1.000	0.002	0.075	0.002
Visibility(mi)	0.002	0.015	0.007	-0.014	0.005	0.007	-0.464	0.004	0.007	0.078	0.003	0.012	0.001	0.228	0.002	0.002	1.000	0.010	0.055
Wind_Direction	0.023	0.183	0.054	0.001	0.005	0.010	0.084	0.029	0.006	0.077	0.007	0.097	0.009	0.083	0.006	0.075	0.010	1.000	0.002
Wind_Speed(mph)	0.000	0.001	0.001	-0.005	-0.038	0.000	-0.199	0.000	0.000	0.000	0.000	0.001	0.000	0.088	0.000	0.002	0.055	0.002	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Severity	Distance(mi)	Street	Zipcode	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds
2	2	0.01	State Route 32	45176	36.0	100.0	29.67	10.0	SW	3.5	Overcast	False	False	False	False	False	False	False	False	True	Night	1800.0
3	3	0.01	I-75 S	45417	35.1	96.0	29.64	9.0	SW	4.6	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0
4	2	0.01	Miamisburg Centerville Rd	45459	36.0	89.0	29.65	6.0	SW	3.5	Mostly Cloudy	False	False	False	False	False	False	False	False	True	Day	1800.0
5	3	0.01	Westerville Rd	43081	37.9	97.0	29.63	7.0	SSW	3.5	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0
6	2	0.00	N Woodward Ave	45417-2476	34.0	100.0	29.66	7.0	WSW	3.5	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0
7	3	0.01	N Main St	45405	34.0	100.0	29.66	7.0	WSW	3.5	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0
8	2	0.00	Notre Dame Ave	45404-1923	33.3	99.0	29.67	5.0	SW	1.2	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0
9	3	0.01	Westerville Rd	43081	37.4	100.0	29.62	3.0	SSW	4.6	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0
10	3	0.01	Outerbelt S	43228	35.6	93.0	29.64	5.0	WNW	5.8	Rain	False	True	False	True	False	False	False	False	False	Day	1800.0
11	3	0.01	I-70 E	43068	37.4	100.0	29.62	3.0	SSW	4.6	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0

	Severity	Distance(mi)	Street	Zipcode	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds
7728384	2	0.390	I-10 E	91706	78.0	52.0	29.69	10.0	VAR	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1723.0
7728385	2	0.000	CA-60 E	92555	88.0	32.0	28.20	10.0	WNW	10.0	Fair	False	False	False	False	False	False	False	False	False	Day	1703.0
7728386	2	0.189	El Camino Real N	93003	73.0	68.0	29.76	10.0	W	9.0	Fair	False	False	False	True	False	False	False	False	False	Day	1703.0
7728387	2	0.443	Santa Ana Fwy S	92780	75.0	60.0	29.74	10.0	SSW	9.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0
7728388	2	0.000	Golden State Fwy N	91331	81.0	48.0	28.78	10.0	ESE	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0
7728389	2	0.543	Pomona Fwy E	92501	86.0	40.0	28.92	10.0	W	13.0	Fair	False	False	False	False	False	False	False	False	False	Day	1716.0
7728390	2	0.338	I-8 W	92108	70.0	73.0	29.39	10.0	SW	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1613.0
7728391	2	0.561	Garden Grove Fwy	92866	73.0	64.0	29.74	10.0	SSW	10.0	Partly Cloudy	False	False	False	True	False	False	False	False	False	Day	1708.0
7728392	2	0.772	San Diego Fwy S	90230	71.0	81.0	29.62	10.0	SW	8.0	Fair	False	False	False	False	False	False	False	False	False	Day	1761.0
7728393	2	0.537	CA-210 W	92346	79.0	47.0	28.63	7.0	SW	7.0	Fair	False	False	False	False	False	False	False	False	False	Day	1765.0

Most frequently occurring

	Severity	Distance(mi)	Street	Zipcode	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds	# duplicates
66851	2	0.229	Lee Hwy	22031-2318	46.6	68.0	30.36	10.0	WSW	5.8	Clear	False	True	False	False	False	False	False	False	False	Day	3389400.0	28
12943	2	0.000	E Main St	47327	21.7	89.0	30.17	5.0	SW	6.9	Clear	False	False	False	False	False	False	False	False	True	Day	1751.0	13
10831	2	0.000	W Ridge Rd	14559-1029	42.0	89.0	28.98	10.0	NE	5.0	Cloudy	False	False	False	False	False	False	False	False	False	Night	3600.0	12
140493	4	6.625	E Historic Columbia River Hwy	97019	69.0	63.0	30.01	10.0	VAR	3.0	Fair	False	False	False	False	False	False	False	False	False	Day	417709.0	12
121516	2	3.189	I-84 E	97058	25.0	80.0	29.62	2.0	SE	5.0	Light Snow	False	False	False	False	False	False	False	False	False	Night	28089.0	11
126843	2	7.424	I-84 E	97058	25.0	80.0	29.62	2.0	SE	5.0	Light Snow	False	False	False	False	False	False	False	False	False	Night	28089.0	11
129218	3	0.000	Augusta Rd	29073	75.0	100.0	29.74	1.0	SE	13.8	Rain	False	False	False	False	False	False	False	False	False	Day	1661.0	11
130737	3	0.000	I-66 E	22030	61.0	83.0	30.22	10.0	SE	9.2	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1737.0	11
131293	3	0.000	I-95 N	33179	78.0	100.0	29.91	10.0	S	5.0	Partly Cloudy	False	False	False	False	False	False	False	False	False	Day	2635.0	11
140482	4	6.625	E Historic Columbia River Hwy	97019	55.0	83.0	29.95	10.0	E	5.0	Fair	False	False	False	False	False	False	False	False	False	Day	604546.0	11

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring